package com.seraph.zys.dao.impl;

import com.seraph.bi.suite.support.domain.pagination.PageBox;
import com.seraph.bi.suite.support.domain.pagination.PageObject;
import com.seraph.zys.dao.PcFundsArrangementDAO;
import com.seraph.zys.dao.domain.PcFundsArrangement;
import com.seraph.zys.dao.domain.PcFundsArrangementExample;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.stereotype.Repository;

@Repository
public class PcFundsArrangementDAOImpl extends SqlMapClientDaoSupport implements PcFundsArrangementDAO {

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public PcFundsArrangementDAOImpl() {
        super();
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public Integer insert(PcFundsArrangement record) {
        Object newKey = getSqlMapClientTemplate().insert("pc_funds_arrangement.abatorgenerated_insert", record);
        return (Integer) newKey;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public int updateByPrimaryKey(PcFundsArrangement record) {
        int rows = getSqlMapClientTemplate().update("pc_funds_arrangement.abatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public int updateByPrimaryKeySelective(PcFundsArrangement record) {
        int rows = getSqlMapClientTemplate().update("pc_funds_arrangement.abatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public List selectByExample(PcFundsArrangementExample example, String orderByClause) {
        Map parms = getExampleParms(example);
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        List list = getSqlMapClientTemplate().queryForList("pc_funds_arrangement.abatorgenerated_selectByExample", parms);
        return list;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public List selectByExample(PcFundsArrangementExample example) {
        return selectByExample(example, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public PcFundsArrangement selectByPrimaryKey(Integer id) {
        PcFundsArrangement key = new PcFundsArrangement();
        key.setId(id);
        PcFundsArrangement record = (PcFundsArrangement) getSqlMapClientTemplate().queryForObject("pc_funds_arrangement.abatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public int deleteByExample(PcFundsArrangementExample example) {
        int rows = getSqlMapClientTemplate().delete("pc_funds_arrangement.abatorgenerated_deleteByExample", getExampleParms(example));
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public int deleteByPrimaryKey(Integer id) {
        PcFundsArrangement key = new PcFundsArrangement();
        key.setId(id);
        int rows = getSqlMapClientTemplate().delete("pc_funds_arrangement.abatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getIDExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getId_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NULL", "Y");
            } else {
                parms.put("AND_ID_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NOT_NULL", "Y");
            } else {
                parms.put("AND_ID_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_EQUALS", "Y");
            } else {
                parms.put("AND_ID_EQUALS", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ID_NOT_EQUALS", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_GT", "Y");
            } else {
                parms.put("AND_ID_GT", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_GE", "Y");
            } else {
                parms.put("AND_ID_GE", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_LT", "Y");
            } else {
                parms.put("AND_ID_LT", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_LE", "Y");
            } else {
                parms.put("AND_ID_LE", "Y");
            }
            parms.put("id", example.getId());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getFISCAL_YEARExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getFiscalYear_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NULL", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NOT_NULL", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_EQUALS", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_EQUALS", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NOT_EQUALS", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_GT", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_GT", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_GE", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_GE", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_LT", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_LT", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_LE", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_LE", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getFROM_AREAExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getFromArea_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_NULL", "Y");
            } else {
                parms.put("AND_FROM_AREA_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_NOT_NULL", "Y");
            } else {
                parms.put("AND_FROM_AREA_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_EQUALS", "Y");
            } else {
                parms.put("AND_FROM_AREA_EQUALS", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FROM_AREA_NOT_EQUALS", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_GT", "Y");
            } else {
                parms.put("AND_FROM_AREA_GT", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_GE", "Y");
            } else {
                parms.put("AND_FROM_AREA_GE", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_LT", "Y");
            } else {
                parms.put("AND_FROM_AREA_LT", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_LE", "Y");
            } else {
                parms.put("AND_FROM_AREA_LE", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PcFundsArrangementExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_LIKE", "Y");
            } else {
                parms.put("AND_FROM_AREA_LIKE", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getSORT_IDExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getSortId_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_NULL", "Y");
            } else {
                parms.put("AND_SORT_ID_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_NOT_NULL", "Y");
            } else {
                parms.put("AND_SORT_ID_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_EQUALS", "Y");
            } else {
                parms.put("AND_SORT_ID_EQUALS", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SORT_ID_NOT_EQUALS", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_GT", "Y");
            } else {
                parms.put("AND_SORT_ID_GT", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_GE", "Y");
            } else {
                parms.put("AND_SORT_ID_GE", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_LT", "Y");
            } else {
                parms.put("AND_SORT_ID_LT", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_LE", "Y");
            } else {
                parms.put("AND_SORT_ID_LE", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getPROJECT_NAMEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getProjectName_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_NULL", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_NOT_NULL", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_EQUALS", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_EQUALS", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_NOT_EQUALS", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_GT", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_GT", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_GE", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_GE", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_LT", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_LT", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_LE", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_LE", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        case PcFundsArrangementExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROJECT_NAME_LIKE", "Y");
            } else {
                parms.put("AND_PROJECT_NAME_LIKE", "Y");
            }
            parms.put("projectName", example.getProjectName());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getFEEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getFee_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_NULL", "Y");
            } else {
                parms.put("AND_FEE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_FEE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_FEE_EQUALS", "Y");
            }
            parms.put("fee", example.getFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FEE_NOT_EQUALS", "Y");
            }
            parms.put("fee", example.getFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_GT", "Y");
            } else {
                parms.put("AND_FEE_GT", "Y");
            }
            parms.put("fee", example.getFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_GE", "Y");
            } else {
                parms.put("AND_FEE_GE", "Y");
            }
            parms.put("fee", example.getFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_LT", "Y");
            } else {
                parms.put("AND_FEE_LT", "Y");
            }
            parms.put("fee", example.getFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FEE_LE", "Y");
            } else {
                parms.put("AND_FEE_LE", "Y");
            }
            parms.put("fee", example.getFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getCENTRAL_FEEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getCentralFee_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_NULL", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_EQUALS", "Y");
            }
            parms.put("centralFee", example.getCentralFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_NOT_EQUALS", "Y");
            }
            parms.put("centralFee", example.getCentralFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_GT", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_GT", "Y");
            }
            parms.put("centralFee", example.getCentralFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_GE", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_GE", "Y");
            }
            parms.put("centralFee", example.getCentralFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_LT", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_LT", "Y");
            }
            parms.put("centralFee", example.getCentralFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CENTRAL_FEE_LE", "Y");
            } else {
                parms.put("AND_CENTRAL_FEE_LE", "Y");
            }
            parms.put("centralFee", example.getCentralFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getPROVINCIAL_FEEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getProvincialFee_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_NULL", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_EQUALS", "Y");
            }
            parms.put("provincialFee", example.getProvincialFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_NOT_EQUALS", "Y");
            }
            parms.put("provincialFee", example.getProvincialFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_GT", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_GT", "Y");
            }
            parms.put("provincialFee", example.getProvincialFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_GE", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_GE", "Y");
            }
            parms.put("provincialFee", example.getProvincialFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_LT", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_LT", "Y");
            }
            parms.put("provincialFee", example.getProvincialFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_FEE_LE", "Y");
            } else {
                parms.put("AND_PROVINCIAL_FEE_LE", "Y");
            }
            parms.put("provincialFee", example.getProvincialFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getCITY_FEEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getCityFee_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_NULL", "Y");
            } else {
                parms.put("AND_CITY_FEE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_CITY_FEE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_CITY_FEE_EQUALS", "Y");
            }
            parms.put("cityFee", example.getCityFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_CITY_FEE_NOT_EQUALS", "Y");
            }
            parms.put("cityFee", example.getCityFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_GT", "Y");
            } else {
                parms.put("AND_CITY_FEE_GT", "Y");
            }
            parms.put("cityFee", example.getCityFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_GE", "Y");
            } else {
                parms.put("AND_CITY_FEE_GE", "Y");
            }
            parms.put("cityFee", example.getCityFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_LT", "Y");
            } else {
                parms.put("AND_CITY_FEE_LT", "Y");
            }
            parms.put("cityFee", example.getCityFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_FEE_LE", "Y");
            } else {
                parms.put("AND_CITY_FEE_LE", "Y");
            }
            parms.put("cityFee", example.getCityFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getCOUNTRY_FEEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getCountryFee_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_NULL", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_EQUALS", "Y");
            }
            parms.put("countryFee", example.getCountryFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_NOT_EQUALS", "Y");
            }
            parms.put("countryFee", example.getCountryFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_GT", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_GT", "Y");
            }
            parms.put("countryFee", example.getCountryFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_GE", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_GE", "Y");
            }
            parms.put("countryFee", example.getCountryFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_LT", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_LT", "Y");
            }
            parms.put("countryFee", example.getCountryFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_FEE_LE", "Y");
            } else {
                parms.put("AND_COUNTRY_FEE_LE", "Y");
            }
            parms.put("countryFee", example.getCountryFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getSOCIETY_FEEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getSocietyFee_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_NULL", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_EQUALS", "Y");
            }
            parms.put("societyFee", example.getSocietyFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_NOT_EQUALS", "Y");
            }
            parms.put("societyFee", example.getSocietyFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_GT", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_GT", "Y");
            }
            parms.put("societyFee", example.getSocietyFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_GE", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_GE", "Y");
            }
            parms.put("societyFee", example.getSocietyFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_LT", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_LT", "Y");
            }
            parms.put("societyFee", example.getSocietyFee());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SOCIETY_FEE_LE", "Y");
            } else {
                parms.put("AND_SOCIETY_FEE_LE", "Y");
            }
            parms.put("societyFee", example.getSocietyFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getGLOBAL_FOUNDATIONExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getGlobalFoundation_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_NULL", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_NOT_NULL", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_EQUALS", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_EQUALS", "Y");
            }
            parms.put("globalFoundation", example.getGlobalFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_NOT_EQUALS", "Y");
            }
            parms.put("globalFoundation", example.getGlobalFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_GT", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_GT", "Y");
            }
            parms.put("globalFoundation", example.getGlobalFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_GE", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_GE", "Y");
            }
            parms.put("globalFoundation", example.getGlobalFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_LT", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_LT", "Y");
            }
            parms.put("globalFoundation", example.getGlobalFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GLOBAL_FOUNDATION_LE", "Y");
            } else {
                parms.put("AND_GLOBAL_FOUNDATION_LE", "Y");
            }
            parms.put("globalFoundation", example.getGlobalFoundation());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getGATES_FOUNDATIONExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getGatesFoundation_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_NULL", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_NOT_NULL", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_EQUALS", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_EQUALS", "Y");
            }
            parms.put("gatesFoundation", example.getGatesFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_NOT_EQUALS", "Y");
            }
            parms.put("gatesFoundation", example.getGatesFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_GT", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_GT", "Y");
            }
            parms.put("gatesFoundation", example.getGatesFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_GE", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_GE", "Y");
            }
            parms.put("gatesFoundation", example.getGatesFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_LT", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_LT", "Y");
            }
            parms.put("gatesFoundation", example.getGatesFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GATES_FOUNDATION_LE", "Y");
            } else {
                parms.put("AND_GATES_FOUNDATION_LE", "Y");
            }
            parms.put("gatesFoundation", example.getGatesFoundation());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getDAMIEN_FOUNDATIONExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getDamienFoundation_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_NULL", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_NOT_NULL", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_EQUALS", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_EQUALS", "Y");
            }
            parms.put("damienFoundation", example.getDamienFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_NOT_EQUALS", "Y");
            }
            parms.put("damienFoundation", example.getDamienFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_GT", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_GT", "Y");
            }
            parms.put("damienFoundation", example.getDamienFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_GE", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_GE", "Y");
            }
            parms.put("damienFoundation", example.getDamienFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_LT", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_LT", "Y");
            }
            parms.put("damienFoundation", example.getDamienFoundation());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DAMIEN_FOUNDATION_LE", "Y");
            } else {
                parms.put("AND_DAMIEN_FOUNDATION_LE", "Y");
            }
            parms.put("damienFoundation", example.getDamienFoundation());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getOTHER_FEE_ONEExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getOtherFeeOne_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_NULL", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_NOT_NULL", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_EQUALS", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_EQUALS", "Y");
            }
            parms.put("otherFeeOne", example.getOtherFeeOne());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_NOT_EQUALS", "Y");
            }
            parms.put("otherFeeOne", example.getOtherFeeOne());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_GT", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_GT", "Y");
            }
            parms.put("otherFeeOne", example.getOtherFeeOne());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_GE", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_GE", "Y");
            }
            parms.put("otherFeeOne", example.getOtherFeeOne());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_LT", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_LT", "Y");
            }
            parms.put("otherFeeOne", example.getOtherFeeOne());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_ONE_LE", "Y");
            } else {
                parms.put("AND_OTHER_FEE_ONE_LE", "Y");
            }
            parms.put("otherFeeOne", example.getOtherFeeOne());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getOTHER_FEE_SECExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getOtherFeeSec_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_NULL", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_NOT_NULL", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_EQUALS", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_EQUALS", "Y");
            }
            parms.put("otherFeeSec", example.getOtherFeeSec());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_NOT_EQUALS", "Y");
            }
            parms.put("otherFeeSec", example.getOtherFeeSec());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_GT", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_GT", "Y");
            }
            parms.put("otherFeeSec", example.getOtherFeeSec());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_GE", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_GE", "Y");
            }
            parms.put("otherFeeSec", example.getOtherFeeSec());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_LT", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_LT", "Y");
            }
            parms.put("otherFeeSec", example.getOtherFeeSec());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_OTHER_FEE_SEC_LE", "Y");
            } else {
                parms.put("AND_OTHER_FEE_SEC_LE", "Y");
            }
            parms.put("otherFeeSec", example.getOtherFeeSec());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getPROVINCIAL_MEASUREExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getProvincialMeasure_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_NULL", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_NOT_NULL", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_EQUALS", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_EQUALS", "Y");
            }
            parms.put("provincialMeasure", example.getProvincialMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_NOT_EQUALS", "Y");
            }
            parms.put("provincialMeasure", example.getProvincialMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_GT", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_GT", "Y");
            }
            parms.put("provincialMeasure", example.getProvincialMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_GE", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_GE", "Y");
            }
            parms.put("provincialMeasure", example.getProvincialMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_LT", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_LT", "Y");
            }
            parms.put("provincialMeasure", example.getProvincialMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PROVINCIAL_MEASURE_LE", "Y");
            } else {
                parms.put("AND_PROVINCIAL_MEASURE_LE", "Y");
            }
            parms.put("provincialMeasure", example.getProvincialMeasure());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getCITY_MEASUREExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getCityMeasure_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_NULL", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_NOT_NULL", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_EQUALS", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_EQUALS", "Y");
            }
            parms.put("cityMeasure", example.getCityMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_NOT_EQUALS", "Y");
            }
            parms.put("cityMeasure", example.getCityMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_GT", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_GT", "Y");
            }
            parms.put("cityMeasure", example.getCityMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_GE", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_GE", "Y");
            }
            parms.put("cityMeasure", example.getCityMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_LT", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_LT", "Y");
            }
            parms.put("cityMeasure", example.getCityMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_CITY_MEASURE_LE", "Y");
            } else {
                parms.put("AND_CITY_MEASURE_LE", "Y");
            }
            parms.put("cityMeasure", example.getCityMeasure());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getCOUNTRY_MEASUREExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getCountryMeasure_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_NULL", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_NOT_NULL", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_EQUALS", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_EQUALS", "Y");
            }
            parms.put("countryMeasure", example.getCountryMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_NOT_EQUALS", "Y");
            }
            parms.put("countryMeasure", example.getCountryMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_GT", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_GT", "Y");
            }
            parms.put("countryMeasure", example.getCountryMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_GE", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_GE", "Y");
            }
            parms.put("countryMeasure", example.getCountryMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_LT", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_LT", "Y");
            }
            parms.put("countryMeasure", example.getCountryMeasure());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_COUNTRY_MEASURE_LE", "Y");
            } else {
                parms.put("AND_COUNTRY_MEASURE_LE", "Y");
            }
            parms.put("countryMeasure", example.getCountryMeasure());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getGAPExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        switch (example.getGap_Indicator()) {
        case PcFundsArrangementExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_NULL", "Y");
            } else {
                parms.put("AND_GAP_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_NOT_NULL", "Y");
            } else {
                parms.put("AND_GAP_NOT_NULL", "Y");
            }
            break;
        case PcFundsArrangementExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_EQUALS", "Y");
            } else {
                parms.put("AND_GAP_EQUALS", "Y");
            }
            parms.put("gap", example.getGap());
            break;
        case PcFundsArrangementExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_GAP_NOT_EQUALS", "Y");
            }
            parms.put("gap", example.getGap());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_GT", "Y");
            } else {
                parms.put("AND_GAP_GT", "Y");
            }
            parms.put("gap", example.getGap());
            break;
        case PcFundsArrangementExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_GE", "Y");
            } else {
                parms.put("AND_GAP_GE", "Y");
            }
            parms.put("gap", example.getGap());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_LT", "Y");
            } else {
                parms.put("AND_GAP_LT", "Y");
            }
            parms.put("gap", example.getGap());
            break;
        case PcFundsArrangementExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_GAP_LE", "Y");
            } else {
                parms.put("AND_GAP_LE", "Y");
            }
            parms.put("gap", example.getGap());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    private Map getExampleParms(PcFundsArrangementExample example) {
        Map parms = new HashMap();
        parms.putAll(getIDExampleParms(example));
        parms.putAll(getFISCAL_YEARExampleParms(example));
        parms.putAll(getFROM_AREAExampleParms(example));
        parms.putAll(getSORT_IDExampleParms(example));
        parms.putAll(getPROJECT_NAMEExampleParms(example));
        parms.putAll(getFEEExampleParms(example));
        parms.putAll(getCENTRAL_FEEExampleParms(example));
        parms.putAll(getPROVINCIAL_FEEExampleParms(example));
        parms.putAll(getCITY_FEEExampleParms(example));
        parms.putAll(getCOUNTRY_FEEExampleParms(example));
        parms.putAll(getSOCIETY_FEEExampleParms(example));
        parms.putAll(getGLOBAL_FOUNDATIONExampleParms(example));
        parms.putAll(getGATES_FOUNDATIONExampleParms(example));
        parms.putAll(getDAMIEN_FOUNDATIONExampleParms(example));
        parms.putAll(getOTHER_FEE_ONEExampleParms(example));
        parms.putAll(getOTHER_FEE_SECExampleParms(example));
        parms.putAll(getPROVINCIAL_MEASUREExampleParms(example));
        parms.putAll(getCITY_MEASUREExampleParms(example));
        parms.putAll(getCOUNTRY_MEASUREExampleParms(example));
        parms.putAll(getGAPExampleParms(example));
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public int selectCountByExample(PcFundsArrangementExample example) {
        Map parms = getExampleParms(example);
        int count = ((Integer)getSqlMapClientTemplate().queryForObject("pc_funds_arrangement.abatorgenerated_selectCountByExample", parms)).intValue();
        return count;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public PageBox selectByExampleWithPaging(PcFundsArrangementExample example, int pageSize, int pageNum, String orderByClause) {
        Map parms = getExampleParms(example);
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        PageBox pageBox = new PageBox();
        PageObject pageObject = new PageObject();
        pageObject.setPageSize(pageSize);
        pageObject.setPageIndex(pageNum);
        int itemAmount = selectCountByExample(example);
        pageObject.setItemAmount(itemAmount);
        List pageList = null;
        if (pageObject.getBeginIndex() <= pageObject.getItemAmount()) {
            pageList = (getSqlMapClientTemplate().queryForList("pc_funds_arrangement.abatorgenerated_selectByExample", parms, pageObject.getBeginIndex() - 1, pageSize));
        }
        pageBox.setPageObject(pageObject);
        pageBox.setPageList(pageList);
        return pageBox;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public PageBox selectByExampleWithPaging(PcFundsArrangementExample example, int pageSize, int pageNum) {
        return selectByExampleWithPaging(example, pageSize, pageNum, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pc_funds_arrangement
     *
     * @abatorgenerated Tue Apr 17 10:39:40 CST 2012
     */
    public int updateByPrimaryKeyForCgs(PcFundsArrangement record) {
        int rows = getSqlMapClientTemplate().update("pc_funds_arrangement.abatorgenerated_updateByPrimaryKeyForCgs", record);
        return rows;
    }
}